Enoteca Italiana
see above, in eat has excellent and non pretentious sommeliers on hand to advise and guide you. great place for a lovely glass of wine.
Golem
A very pleasant outdoor trattoria and wine bar on piazza san martino, has a relaxed, modern italian atmosphere and is great for people watching. reasonable prices, excellent wines, and a small appetizer bar make it ideal for a long evening of good drink with friends or family. also, the gnocchi with crab sauce is superb, although you might want to avoid it if you're squeamish about crab parts.
Consider visiting the many pubs and clubs of Via Zamboni university zone; some, such as "The Irish Pub", popular with students and foreigners, give happy hours on Tuesday/Wednesday. "Al Piccolo" down the road in Piazza Verdi is another famous student haunt, a live DJ playing techno into the early mornings. Otherwise, the Via Pratello has many bars and is the center of the city's alternative scene. Worth a look in particular is "Mutanye", whose owner is reputed to have been part of the Red Brigade in his youth, hence the many soviet posters. Via Mascarella, in the northeast area of the city, has plenty of nightspots, among them two jazz clubs. And, finally, check out the many bars and pubs hosting music contests and concerts, from rock to jazz to "liscio", the traditional folk songs in Emilia-Romagna.
Ai Vini Scelti
A good enoteca winery, just outside the center in via andrea costa and only a few moments from via pratello, is considered one of the best in bologna, though there are many others in the center, providing everything from a quick aperitivo to proper wine-tasting. another good winery is "vini d'italia" in emilia levante street viale lenin corner, which is one of the oldest on in the city.